Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_CAPTURE_PREPARED_DATABASE

`ALL_CAPTURE_PREPARED_DATABASE` displays information about when the local database was prepared for instantiation. If the local database was not prepared for instantiation, then this view contains no rows.

Related View

`DBA_CAPTURE_PREPARED_DATABASE` displays information about when the local database was prepared for instantiation.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TIMESTAMP` | `DATE` |  | Date and time at which the local database was ready to be instantiated
`SUPPLEMENTAL_LOG_DATA_PK` | `VARCHAR2(8)` |  | Status of database-level PRIMARY KEY COLUMNS supplemental logging
`SUPPLEMENTAL_LOG_DATA_UI` | `VARCHAR2(8)` |  | Status of database-level UNIQUE INDEX COLUMNS supplemental logging
`SUPPLEMENTAL_LOG_DATA_FK` | `VARCHAR2(8)` |  | Status of database-level FOREIGN KEY COLUMNS supplemental logging
`SUPPLEMENTAL_LOG_DATA_ALL` | `VARCHAR2(8)` |  | Status of database-level ALL COLUMNS supplemental logging

See Also: "DBA_CAPTURE_PREPARED_DATABASE" Oracle Streams Replication Administrator's Guide for more information about the possible values for the supplemental logging columns in this view